Creating line and stacked column with Week Duration 15


a.       Creating line and stacked column for week duration

On field and shared axis Week Duration column, and  column value WORDS PER DAY and Line value Completeness but change the name only for Visual .  click down the arrow and choose Rename for this visual   (completeness%)

b.       To Format, Go to General X position = 764, y position =450, width = 636 height = 450

c.        Legend = ON color black (000000) font family =Cambria Math, text 12 style =markers only, Match line color =on, circle default icon =on

d.       x-axis color black, text size 15, font family = Cambria Math, minimum category width 20 Max = 20 Inner padding 20% concatenate labels on, Title off 

e.       y-axis color(605E5C) text size 15,  font family Cambria Math and title =off

f.          Gridlines on color (B3B3B3) stoke width 1, line style =solid , show secondary= on Align zeros= On

g.       Y-Axis(Line), color (009292) text Size 16 font family Cambria Math, Title= off

h.       data Colors ,completeness % = (009292), Default color( 99CDE7)

i.         Data labels On, color(8952BF )text size 16, font family Cambria Math, ,show background on , background color  =white  transparency  30%

j.         customize series on , WORDS PER DAY color (EC8FCA) text size =16

font family Cambria Math, show background =on, background color = white

k.        shapes area On, stroke width 0, join types Miter Line style solid

l.         Tittle on ‘WORDS PER DAY BY WEEK’ , word wrap on font color black, background color(6DB6FF),alignment = center , text size = 17  font family =Cambria Math

m.     Background = off

n.       Lock aspect =off

o.       Border = off

p.       Tooltip = on

q.       Visual header= on


 for 12 week please drug and drop  on add filter filed  and  select Last  12 weeks see on screenshot   


please follow the gif 





Learn more about KPIs here:

https://www.optimizesmart.com/understanding-key-performance-indicators-kpis-just-like-that/#a18